<%@page import="java.sql.PreparedStatement"%>
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<%

querry="update emp_expense set=emp_id,cust_id,complaint_id,call_performed_id,issue_closed_date,ta,fe,lodge,other,total,status,data_status)";
querry=querry+"values(?,?,?,?,to_date(?,'yyyy-mm-dd'),coalesce(?,0),coalesce(?,0),coalesce(?,0),coalesce(?,0),coalesce(?,0),?,?)";
PreparedStatement prst1=con.prepareStatement(querry);
	prst1.setInt(1,Integer.parseInt(emp_eid));
	prst1.setInt(2,Integer.parseInt(cust_id));
	prst1.setString(3,complaint_id);
	prst1.setInt(4,call_performed_id);
 	prst1.setString(5,servicedate);
	prst1.setInt(6,Integer.parseInt(ta));
	prst1.setInt(7,Integer.parseInt(fe));
	prst1.setInt(8,Integer.parseInt(lodge));
	prst1.setInt(9,Integer.parseInt(other));
	prst1.setInt(10,Integer.parseInt(total));
	prst1.setString(11,"V");
	prst1.setString(12,"MANUAL");
	boolean result1= prst1.execute();
%>
</body>
</html>